SGG-MDM Upload Device Measurements (Echelon) Description This section includes detailed descriptions of the steps involved in the SGG-MDM Upload Device Measurements (Echelon) business process, including: • 1.0 Analyze Requirements to Send Request • 1.1 Submit Request for Usage Extract Payload for Period • 1.2 Preprocess and Create Scheduler in Pending Status • 1.3 Transition to Active Status • 1.4 Monitor and Initiate Extract Request Processing • 1.5 Create and Send Extract Request, Transition to Send Request Status • 1.6 Communicate and Transform Extract Request to Echelon Format • 1.7 Process Request • 1.8 Send Positive or Negative Response • 1.9 Process Response • 2.0 Evaluate Response • 2.1 Transition Extract Scheduler to Request Error State and Log Error • 2.2 Create To Do • 2.3 Review Active Request • 2.4 Request to Send Extract Request • 2.5 Populate Required Changes • 2.6 Update Extract Request • 2.7 Request Delete Activity • 2.8 Delete Activity • 2.9 Request Inactivate Extract Request • 3.0 Transition Activity to Inactive • 3.1 Process Request and Create Meter Reads Payload • 3.2 Poll File Location • 3.3 Parse, Analyze File and Identify Records • 3.4 Transform Meter Read Record to 'Plain' XML • 3.5 Process Message Through Notifications Generator • 3.6 Create and Send Statistical Notification • 3.7 Route Notification Through JMS Queue to OUAF • 3.8 Create and Publish Additional Notification(s) • 3.9 Perform Custom Pre-Processing • 4.0 Validate Meter Read Record • 4.1 Transform "Plane" XML Meter Read Record to SGG IMD Standard Format • 4.2 Create and Send Error Notification • 4.3 Perform Custom Post-Processing • 4.4 Send IMD Record • 4.5 Route IMD Record Through JMS Queue to OUAF • 4.6 Determine Head-End System, Device, Measuring Component, and UOM • 4.7 Populate Start Date/Time & End Date/Time • 4.8 Adjust Date/Time in Multiples of SPI and Convert to Standard Time considering DST • 4.9 Check Interval Data Integrity • 5.0 Determine Processing Method • 5.1 Create IMD in 'Error' State and Log Errors • 5.2 Populate Default Data • 5.3 Create IMD Record in 'Pending' State • 5.4 Process Pending IMDs • 5.5 Perform Echelon Head-End Specific Mapping and Update State to 'Additional Mapping' • 5.6 Calculate Pre-VEE Values and Consumption • 5.2 Populate Default Data • 5.8 Review IMD • 5.9 Populate Changes and Request to Update IMD • 6.0 Update IMD • 6.1 Request to Perform Additional Mapping • 6.2 Request to Delete • 6.3 Delete IMD • 6.4 Gather IMD Requirements • 6.5 Submit Request • 6.6 Check for any Missing Interval Data • 6.7 Check If Data Is Within Boundary Of Previous Day Data • 6.8 Update IMD to 'VEE Ready' State • 6.9 Update IMD to 'Error' State and Log Errors • 7.0 4.2.1.2 MDM. V2.0.1. Manage VEE and VEE Exceptions. Manage VEE • 7.1 4.2.1.2 MDM. Manage VEE and VEE Exceptions. Finalize IMD • 7.2 Preprocess Activity • 7.3 Create Pending Payload Statistics Activity • 7.4 Validate Notification Data (Service Provider, File Name) • 7.5 Transition Activity to Validation Error State and Log Error • 7.6 Transition To Active State • 7.7 Monitor Statistic Aggregation • 7.8 Transition Activity to Inactive • 7.9 Accumulate File Statistics for Events and IMDs • 8.0 Review Active Payload Statistic Records • 8.1 Request Accumulate Statistics • 8.2 Request Inactivate Payload Statistics • 8.3 Request Delete Payload Statistics • 8.4 Delete Payload Statistics • 8.5 Preprocess Activity • 8.6 Create Pending Payload Error Notification Activity • 8.7 Find Payload Statistics for Processed Payload and Transition to Validate State • 8.8 Update Payload Statistics with Error Information and Transition to Completed State • 8.9 Preprocess Activity • 9.0 Create Pending Payload Summary Activity • 9.1 Update Payload Statistics with Payload Summary and Transition to Complete State • 9.2 Analyze, Work Errors and To Do • 9.3 Complete To Dos • 9.4 Update and Request to Retry • 9.5 Update Payload Extract Scheduler status to Retry • 9.6 Identify Activity in Error State • 9.7 Evaluate Criteria to Run Automated Retry Process • 9.8 Request to Reprocess • 9.9 Transition Activity Status to Validate and Initialize Reprocessing • 10.0 Identify Activity in Validation Error State • 10.1 Contact Vendor • 9.2 Review Error • 9.3 Resolve Error • 7.5 Request to Discard • 7.6 Complete To Do(s) • 7.7 Update IMD to 'Discard' State • 7.8 Request to Reprocess • 7.9 Update IMD to 'Reprocessed' State and Initialize Reprocessing • 8.0 Identify IMD in 'Error' State • 8.1 Request to Remove • 8.2 Update IMD to 'Remove' State • 8.3 Update IMD to 'Additional Mapping' State and Continue Processing • 8.4 Evaluate Criteria to Run Automated Retry Process • 8.5 Identify IMD in 'Mapping Error' State • 8.6 Update IMD to 'VEE Ready' State and Continue Processing • 8.7 Identify IMD in 'Error' State